Skip Headers

Pro*PL/1® Supplement to the Oracle Precompilers Guide Release 1.8 Part Number B14353-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I L M N O P Q R S U V W

## A

  ADDR built-in function
    use in SQLADR procedure, 5.2.1
  automatic logins, 1.13.1

## B

  bind descriptor, 5.2.1
    descriptor areas, 5.2.1
  bind descriptor area, 5.2.1
  bind SQLDA
    purpose of, 5.1.3

## C

  CHAR
    Oracle external datatype, 5.2.5.4
  CLOSE statement
    use in Dynamic SQL Method 4, 5.4.17
  colon
    use of with host variables, 1.3.2
  comments
    ANSI-style, 1.1.1
    PL/I-style, 1.1.1
  compiling, 3.5
  conditional precompilation
    benefits of, 3.3
    purpose of, 3.3
  connecting to Oracle
    automatically, 1.13.1
  CONTINUE action
    in the WHENEVER statement, 2.4
  Conventions
    description of, Preface
    Notation, Preface
  cursor
    closing, 5.4.17
    declaration of, 5.4.8
    opening, 5.4.12
    restricted scope of, 3.4.1
  cursor cache
    purpose of, 2.5

## D

  Data Definition Language
    creating CHAR objects with DBMS=V6, 3.2.5
  datatype codes, 5.2.5
    defined, 5.2.5.1
    list of, 5.2.5.4
  datatype conversions, 1.10
  datatype equivalencing, 1.11
    example of, 1.11.1
  datatypes, 5.2.5
    coercing, 5.2.5.2
    coercing NUMBER to VARCHAR2, 5.2.5.3
    external, 5.2.5.1
    internal, 5.2.5.1
  DATE
    Oracle external datatype, 5.2.5.4
  DECIMAL
    Oracle external datatype, 5.2.5.4
  declaration
    of host arrays, 1.5.1
    of host variables, 1.3.1
    of indicator variables, 1.4.1
    of ORACA, 2.5.1
    of SQLCA, 2.2.1
    of SQLDA, 5.2.2
  DECLARE CURSOR statement
    use in Dynamic SQL Method 4, 5.4.8
  declare section
    PL/I datatypes allowed in, 1.3.1
    purpose of, 1.2.1
    rules for defining, 1.2.1
    statements allowed in, 1.2.1
  default
    error handling, 2.4
    setting of ORACA option, 2.5.2
  DESCRIBE BIND VARIABLES statement
    use in Dynamic SQL Method 4, 5.4.9
  DESCRIBE SELECT LIST statement
    use in Dynamic SQL Method 4, 5.4.13
  descriptor areas, 5.2.1
    select descriptor, 5.2.1
  descriptors
    reserved elements in, 5.2.4.16
  directory
    current, 1.2.2
  directory path
    for INCLUDE files, 1.2.2
  DISPLAY
    Oracle external datatype, 5.2.5.4
  DO action
    in the WHENEVER statement, 2.4
  Dynamic SQL Method 1
    program example, 4.7
  Dynamic SQL Method 2
    program example, 4.8
  Dynamic SQL Method 3
    program example, 4.9
  Dynamic SQL Method 4
    requirements of, 5.1.1
    sequence of statements used with, 5.4
    steps for, 5.3
    use of CLOSE statement in, 5.4.17
    use of DECLARE CURSOR statement in, 5.4.8
    use of DESCRIBE statement in, 5.4.9, 5.4.13
    use of FETCH statement in, 5.4.15
    use of OPEN statement in, 5.4.12
    use of PREPARE statement in, 5.4.7

## E

  embedded PL/SQL
    requirements for, 1.12
    using host variables with, 1.12.1
    using indicator variables with, 1.12.2
    where allowed, 1.12
  embedded SQL
    requirements for, 1.1.3
    syntax for, 1.1.3
  embedded SQL statements
    comments in, 1.1.1
    labels for, 1.1.14
    referencing host variables in, 1.3.2
    referencing indicator variables in, 1.4.2
    terminator for, 1.1.13
    use of, 1.1.11
    use of apostrophes in, 1.1.11
  equivalencing of datatypes, 1.11
  error message text
    use in error reporting, 2.2.3.5
    using the SQLGLM function to get, 2.3
  error messages
    maximum length of, 2.3
  error reporting
    key components of, 2.2.3
    use of error message text in, 2.2.3.5
    use of parse error offset in, 2.2.3.4
    use of rows-processed count in, 2.2.3.3
    use of status codes in, 2.2.3.1
    use of warning flags in, 2.2.3.2
  EXEC ORACLE statement
    syntax for, 3.2.7
    using to enter options inline, 3.2.7
  EXEC SQL clause
    using to embed SQL statements, 1.1.3
  EXECUTE statement
    use in Dynamic SQL Method 4, 5.5
    use with host arrays, 5.5
  external datatype
    defined, 5.2.5.1
  external datatypes, 5.2.5.1
    list of, 1.9.2

## F

  FETCH statement
    use in Dynamic SQL Method 4, 5.4.15
  file extension
    for INCLUDE files, 1.2.2
  flags
    warning flags, 2.2.3.2
  FLOAT
    Oracle external datatype, 5.2.5.4
  functions
    precompiling, 3.4

## G

  GOTO action
    in the WHENEVER statement, 2.4

## H

  host arrays
    declaring, 1.5.1
    multidimensional, 1.5.1
    restrictions on, 1.5.1, 1.5.2
  host variables
    attribute factoring in declaration of, 1.3.1.2
    compatibility with database objects, 1.3.1
    declaring, 1.3.1
    definition of, 1.1.4
    naming, 1.3.2
    passed to a subroutine, 1.3.1.3
    referencing, 1.3.2
    restrictions on, 1.6
    rules for naming, 1.1.4
    scope of, 1.1.12
    using with PL/SQL, 1.12.1
    where to declare, 1.2.1, 1.3.1.3

## I

  INAME option
    when a file extension is required, 3.1
  INCLUDE statement
    effect of, 1.2.2
    not like PL/I %INCLUDE directive, 1.2.2
    using to declare the ORACA, 2.5.1
    using to declare the SQLCA, 2.2.1
    using to declare the SQLDA, 5.2.2
  indicator variables, 1.4
    association with host variables, 1.4
    declaring, 1.4.1
    function of, 1.4
    referencing, 1.4.2
    required size of, 1.4.1
    using with PL/SQL, 1.12.2
  insert of no rows
    cause of, 2.1.4
  internal datatype, 5.2.5.1
    defined, 5.2.5.1
  internal datatypes
    list of, 1.9.1
  IS NULL operator
    for testing nulls, 1.1.6

## L

  LIKE attribute
    cannot be used for host variables, 1.3.1.1
  linking, 3.5
  LMARGIN, 3.2.8
  logical operators, 1.1.7
  LONG
    Oracle external datatype, 5.2.5.4
  LONG RAW
    Oracle external datatype, 5.2.5.4
  LONG VARRAW
    Oracle external datatype, 5.2.5.4, 5.2.5.4

## M

  MAXLITERAL
    default value, 1.1.5
  message text
    error message text, 2.2.3.5
  MLSLABEL
    Oracle external datatype, 5.2.5.4
  MODE option
    default value for, 3.2.6
    effects of, 1.8.1
    purpose of, 3.2.6
    syntax for, 3.2.6
    usage notes for, 3.2.6
  multidimensional arrays
    cannot be declared as host variables, 1.5.1
    invalid use of, 1.5.1

## N

  naming
    of host variables, 1.1.4
  NOT FOUND condition
    in the WHENEVER statement, 2.4
  Notation
    rules for, Preface
    Conventions, Preface
  NULL
    meaning of in SQL, 1.1.6
    PL/I built-in function, 1.1.6
  null values
    handling in Dynamic SQL Method 4, 5.2.6
    using the SQLNUL procedure to test for, 5.2.6
  NUMBER datatype
    using the SQLPRC procedure with, 5.2.5.3
  NVL function
    for retrieving nulls, 1.1.6

## O

  OPEN statement
    use in Dynamic SQL Method 4, 5.4.12
  operators
    relational, 1.1.8
  options
    precompiler, 3.2
  ORACA
    declaring, 2.5.1
    enabling, 2.5.2
    fields in, 2.5.3
    purpose of, 2.5
  ORACLE Communications Area
    ORACA, 2.5
  Oracle Precompilers
    use of PL/SQL with, 1.12

## P

  parse error offset
    how to interpret, 2.2.3.4
    use in error reporting, 2.2.3.4
  PL/I
    BASED variables, 1.6
    labels, 1.1.14
    preprocessor not supported, 1.1.10
    use of apostrophes in, 1.1.11
    use of pointers in embedded SQL, 1.6
  PL/I datatypes
    allowed in SQL declare section, 1.3.1
    CHARACTER VARYING, 1.7
    FIXED DECIMAL, 5.2.4.6
    supported by Oracle Precompilers, 1.3.1
  PL/SQL
    embedded PL/SQL, 1.12
  pointers
    use of in PL/I, 1.6
  precision
    extracting, 5.2.5.3
    in the FIXED DECIMAL PL/I datatype, 5.2.4.6
  precision and scale
    using the SQLPRC procedure to extract, 5.2.5.3
  precompiler command
    issuing, 3.1
    optional arguments of, 3.2
    required arguments, 3.1
  Precompiler options
    MODE, 3.2.6
  precompiler options
    default settings, 3.2
    displaying, 3.2
    entering inline, 3.2.7
    inline versus on the command line, 3.2.7
    respecifying, 3.2.4
    scope of, 3.2.4
    scope of inline options, 3.2.7
    specifying, 3.2
  PREPARE statement
    use in Dynamic SQL Method 4, 5.4.7
  preprocessor
    not supported in SQL blocks, 1.1.10
  procedures
    declare section in, 1.3.1.3
  pseudocolumns
    list of, 1.9.2

## Q

  quotation marks
    use of in embedded SQL, 1.1.11

## R

  RAW
    Oracle external datatype, 5.2.5.4
  referencing
    of host variables, 1.3.2
    of indicator variables, 1.4.2
  relational operators, 1.1.8
  restrictions
    on host arrays, 1.5.2
    on PL/I variables, 1.6
  RMARGIN, 3.2.8
  ROWID
    Oracle external datatype, 5.2.5.4
  rows-processed count
    use in error reporting, 2.2.3.3

## S

  scale
    extracting, 5.2.5.3
    in the FIXED DECIMAL PL/I datatype, 5.2.4.6
    when negative, 5.2.5.3
  scope
    of host variables, 1.1.12
    of precompiler options, 3.2.4
    of WHENEVER statement, 2.4.1
  select descriptor, 5.2.1
  select descriptor area, 5.2.1
  select SQLDA
    purpose of, 5.1.3
  Separate compilation
    restrictions on, 3.4.1
  separate precompilation
    definition of, 3.4
    need for, 3.4
  SQL statement
    terminator for, 1.1.13
  SQL*Forms user exit
    sample program, 4.6
  SQLADR procedure
    syntax of, 5.2.1
    use of, 5.2.1
  SQLCA
    declaring, 2.2.1
    purpose of, 2.2
  SQLCODE variable, 2.2.3.1
    declaring, 2.1.4
    interpreting values of, 2.1.4
  SQLDA
    datatypes in, 5.2.5
    declaring, 5.2.2
    SQLDFMT element in, 5.2.4.6
    SQLDFND element in, 5.2.4.3
    SQLDH_CUR_VNAMEL element in, 5.2.4.12
    SQLDH_MAX_VNAME element in, 5.2.4.11
    SQLDH_VNAME element in, 5.2.4.10
    SQLDI element in, 5.2.4.9
    SQLDI_CUR_VNAMEL element in, 5.2.4.15
    SQLDI_MAX_VNAMEL element in, 5.2.4.14
    SQLDI_VNAME element in, 5.2.4.13
    SQLDNUM element in, 5.2.4.2
    SQLDSC element in, 5.2.4.4
    SQLDV element in, 5.2.4.6
    SQLDVLN element in, 5.2.4.7
    SQLDVTYP element in, 5.2.4.8
    structure, 5.2.4
    variables, 5.2.4
  SQLDFMT
    element in SQLDA, 5.2.4.6
  SQLDFMT element in SQLDA
    how value is set, 5.2.4.6
  SQLDFND element in SQLDA
    how value is set, 5.2.4.3
  SQLDH_CUR_VNAME element in SQLDA
    how value is set, 5.2.4.12
  SQLDH_MAX_VNAME element in SQLDA
    how value is set, 5.2.4.11
  SQLDH_VNAME element in SQLDA
    how value is set, 5.2.4.10
  SQLDI element in SQLDA
    how value is set, 5.2.4.9
  SQLDI_CUR_VNAMEL element in SQLDA
    how value is set, 5.2.4.15
  SQLDI_MAX_VNAMEL element in SQLDA
    how value is set, 5.2.4.14
  SQLDI_VNAME element in SQLDA
    how value is set, 5.2.4.13
  SQLDNUM element in SQLDA
    how value is set, 5.2.4.2
  SQLDSC element in SQLDA
    how N is set, 5.2.4.4
  SQLDV element in SQLDA
    how value is set, 5.2.4.6
  SQLDVLN
    must be set by program, 5.2.4.7
  SQLDVLN element in SQLDA
    how value is set, 5.2.4.7
  SQLDVTYP element in SQLDA
    how it is used, 5.2.5
    how value is set, 5.2.4.8
  SQLERRD(3) variable, 2.2.3.3
  SQLERRM variable, 2.2.3.5
  SQLERROR condition
    in the WHENEVER statement, 2.4
  SQLGLM function
    example of using, 2.3
    need for, 2.3
    parameters of, 2.3
    syntax for, 2.3
  SQLNUL procedure
    example of using, 5.2.6
    parameters of, 5.2.6
    purpose of, 5.2.6
    syntax for, 5.2.6
    use of with SQLDVTYP, 5.2.4.8
  SQLPR2 procedure
    purpose of, 5.2.5.3
  SQLPRC procedure
    example of using, 5.2.5.3
    parameters of, 5.2.5.3
    purpose of, 5.2.5.3
    syntax for, 5.2.5.3
  SQLSTATE
    class codes, 2.1.2
    declaring, 2.1.1
    mapping to Oracle errors, 2.1.2
    predefined classes, 2.1.2
    status codes, 2.1.2
    using, 2.1.3
    values, 2.1.2
  SQLWARNING condition
    in the WHENEVER statement, 2.4
  statement labels, 1.1.14
  status codes
    use in error reporting, 2.2.3.1
  STOP action
    in the WHENEVER statement, 2.4
  STRING
    Oracle external datatype, 5.2.5.4
  structure
    elements in allowed as host variable, 1.3.1.1
    use of as host variable not allowed, 1.3.1.1
  subroutines
    declare section in, 1.3.1.3
    precompiling, 3.4
  syntax
    embedded SQL, 1.1.3

## U

  UNSIGNED
    Oracle external datatype, 5.2.5.4

## V

  VAR statement
    syntax for, 1.11.1
  VARCHAR2
    Oracle external datatype, 5.2.5.4
  VARRAW
    Oracle external datatype, 5.2.5.4

## W

  warning flags
    use in error reporting, 2.2.3.2
  WHENEVER statement
    automatic checking of SQLCA with, 2.4
    CONTINUE action in, 2.4
    DO action in, 2.4
    GOTO action in, 2.4
    maintaining addressability for, 2.4.1.2
    NOT FOUND condition in, 2.4
    scope of, 2.4.1
    SQLERROR condition in, 2.4
    SQLWARNING condition in, 2.4
    STOP action in, 2.4
    syntax for, 2.4
    uses for, 2.4